Duplicate and Paste the visual and change the values for each visual: 15


1-     Ctrl + C on the By Crossing Border visual

2-      Ctrl + V three times

3-     Drag and drop them in the spaces adjacent to each other on the canvas.


Step 1: Group and Replacing Values for By Crossing Method


1-      Enter Crossing Method in the shared axis from Border Crossing table.

2-      Enter Border into the Column Series from the Border Crossing table.

3-      Enter Crossing PM in the Column Values from Key Measures table.

4-      Enter MoM% and YoY% into the Line Values from Key Measures table.

5-      Enter MoM% and YoY% into the Tooltips.

6-      Title On and change the title to By Crossing Method

 Step 2: By Crossing Region


1-      Enter Region & State in the shared axis from Border Crossing table.

2-      Enter Border into the Column Series from the Border Crossing table.

3-      Enter Crossing PM in the Column Values from Key Measures table.

4-      Enter MoM% and YoY% into the Line Values from Key Measures table.

5-      Enter MoM% and YoY% into the Tooltips.

6-      Title On and change the title to By Crossing Region

 Step 3: Change the Visual to filled Map.


1-      Enter State in the shared axis from Border Crossing table.

2-      Enter Crossing PM, MoM% and YoY% into the Tooltips.

3-      Data colors Conditional formatting

a.       Format by color

b.       Based on Crossing PM

c.       Turn on Diverging.

d.       Minimum #07AEF6,

e.       Center Middle Value #EBF705,

f.        Maximum Highest Value #5708F6

4-      Format Map controls Turn off Auto Zoom.

5-      Expand Map Style Theme Gray Scale

6-      Title On and change the title to By Crossing by State

 Step 3-1: Creating Map Legend


1-      Take a screenshot of the Conditional format bar and save.

2-      Insert tab and Pictures to import the legend.

3-      General   X- Position 1038, Y Position 653, Width 127, Height 14

4-      Insert Text Box- General, X- Position 1126, Y Position 66, Width 138, Height 29

5-      Turn off Background.

Copying and pasting formatted values

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting